﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CarFrameWork.Common;
namespace CarFrameWork.Model.CanShuHua
{
	/// <summary>
	/// 类主动齿轮_分动器。
	/// </summary>
	[Serializable]
	public partial class 主动齿轮_分动器
	{
		public 主动齿轮_分动器()
		{}
		#region Model
		private int _id;
		private string _name;
		private string _path;
        private float _a;
		private float _m;
		private float _z;
		private float _ah;
		private float _m1;
		private float _z1;
		private float _a1;
		private float _a2;
		private float _a3;
		private float _a4;
		private float _a5;
		private float _r1;
		private float _r2;
		private float _r3;
		private float _r4;
		private float _d;
		private float _d1;
		private float _d2;
		private float _d3;
		private float _d4;
		private float _d5;
		private float _d6;
		private float _d7;
		private float _d8;
		private float _d9;
		private float _d10;
		private float _d11;
		private float _dhh;
		private float _dh;
		private float _dx;
		private float _l1;
		private float _l2;
		private float _l3;
		private float _l4;
		private float _l5;
		private float _l6;
		private float _l7;
		private float _l8;
		private float _l9;
		private float _l10;
		private float _l11;
		private float _l12;
		private float _l13;
		private float _l14;
		private float _l15;
		private float _l16;
		private float _l17;
		private float _l18;
		private float _l19;
		private float _l20;
		private float _l21;
		private float _l22;
		private float _belta;
		private float _db;
		/// <summary>
		/// 
		/// </summary>
		public int ID
		{
			set{ _id=value;}
			get{return _id;}
		}
		/// <summary>
		/// 
		/// </summary>
		public string name
		{
			set{ _name=value;}
			get{return _name;}
		}
		/// <summary>
		/// 
		/// </summary>
		public string path
		{
			set{ _path=value;}
			get{return _path;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float a
		{
			set{ _a=value;}
			get{return _a;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float m
		{
			set{ _m=value;}
			get{return _m;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float z
		{
			set{ _z=value;}
			get{return _z;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float ah
		{
			set{ _ah=value;}
			get{return _ah;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float m1
		{
			set{ _m1=value;}
			get{return _m1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float z1
		{
			set{ _z1=value;}
			get{return _z1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float A1
		{
			set{ _a1=value;}
			get{return _a1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float A2
		{
			set{ _a2=value;}
			get{return _a2;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float A3
		{
			set{ _a3=value;}
			get{return _a3;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float A4
		{
			set{ _a4=value;}
			get{return _a4;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float A5
		{
			set{ _a5=value;}
			get{return _a5;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float R1
		{
			set{ _r1=value;}
			get{return _r1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float R2
		{
			set{ _r2=value;}
			get{return _r2;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float R3
		{
			set{ _r3=value;}
			get{return _r3;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float R4
		{
			set{ _r4=value;}
			get{return _r4;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D
		{
			set{ _d=value;}
			get{return _d;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D1
		{
			set{ _d1=value;}
			get{return _d1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D2
		{
			set{ _d2=value;}
			get{return _d2;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D3
		{
			set{ _d3=value;}
			get{return _d3;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D4
		{
			set{ _d4=value;}
			get{return _d4;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D5
		{
			set{ _d5=value;}
			get{return _d5;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D6
		{
			set{ _d6=value;}
			get{return _d6;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D7
		{
			set{ _d7=value;}
			get{return _d7;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D8
		{
			set{ _d8=value;}
			get{return _d8;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D9
		{
			set{ _d9=value;}
			get{return _d9;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D10
		{
			set{ _d10=value;}
			get{return _d10;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float D11
		{
			set{ _d11=value;}
			get{return _d11;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float DHH
		{
			set{ _dhh=value;}
			get{return _dhh;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float DH
		{
			set{ _dh=value;}
			get{return _dh;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float DX
		{
			set{ _dx=value;}
			get{return _dx;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L1
		{
			set{ _l1=value;}
			get{return _l1;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L2
		{
			set{ _l2=value;}
			get{return _l2;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L3
		{
			set{ _l3=value;}
			get{return _l3;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L4
		{
			set{ _l4=value;}
			get{return _l4;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L5
		{
			set{ _l5=value;}
			get{return _l5;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L6
		{
			set{ _l6=value;}
			get{return _l6;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L7
		{
			set{ _l7=value;}
			get{return _l7;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L8
		{
			set{ _l8=value;}
			get{return _l8;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L9
		{
			set{ _l9=value;}
			get{return _l9;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L10
		{
			set{ _l10=value;}
			get{return _l10;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L11
		{
			set{ _l11=value;}
			get{return _l11;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L12
		{
			set{ _l12=value;}
			get{return _l12;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L13
		{
			set{ _l13=value;}
			get{return _l13;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L14
		{
			set{ _l14=value;}
			get{return _l14;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L15
		{
			set{ _l15=value;}
			get{return _l15;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L16
		{
			set{ _l16=value;}
			get{return _l16;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L17
		{
			set{ _l17=value;}
			get{return _l17;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L18
		{
			set{ _l18=value;}
			get{return _l18;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L19
		{
			set{ _l19=value;}
			get{return _l19;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L20
		{
			set{ _l20=value;}
			get{return _l20;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L21
		{
			set{ _l21=value;}
			get{return _l21;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float L22
		{
			set{ _l22=value;}
			get{return _l22;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float belta
		{
			set{ _belta=value;}
			get{return _belta;}
		}
		/// <summary>
		/// 
		/// </summary>
		public float DB
		{
			set{ _db=value;}
			get{return _db;}
		}
		#endregion Model


		#region  Method

		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public 主动齿轮_分动器(int ID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select ID,name,path,a,m,z,ah,m1,z1,A1,A2,A3,A4,A5,R1,R2,R3,R4,D,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,DHH,DH,DX,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L16,L17,L18,L19,L20,L21,L22,belta,DB ");
			strSql.Append(" FROM [主动齿轮_分动器] ");
			strSql.Append(" where ID=@ID ");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = ID;

			DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				if(ds.Tables[0].Rows[0]["ID"]!=null && ds.Tables[0].Rows[0]["ID"].ToString()!="")
				{
					this.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
				}
				if(ds.Tables[0].Rows[0]["name"]!=null && ds.Tables[0].Rows[0]["name"].ToString()!="")
				{
					this.name=ds.Tables[0].Rows[0]["name"].ToString();
				}
				if(ds.Tables[0].Rows[0]["path"]!=null && ds.Tables[0].Rows[0]["path"].ToString()!="")
				{
					this.path=ds.Tables[0].Rows[0]["path"].ToString();
				}
				if(ds.Tables[0].Rows[0]["a"]!=null && ds.Tables[0].Rows[0]["a"].ToString()!="")
				{
					this.a=float.Parse(ds.Tables[0].Rows[0]["a"].ToString());
				}
				if(ds.Tables[0].Rows[0]["m"]!=null && ds.Tables[0].Rows[0]["m"].ToString()!="")
				{
					this.m=float.Parse(ds.Tables[0].Rows[0]["m"].ToString());
				}
				if(ds.Tables[0].Rows[0]["z"]!=null && ds.Tables[0].Rows[0]["z"].ToString()!="")
				{
					this.z=float.Parse(ds.Tables[0].Rows[0]["z"].ToString());
				}
				if(ds.Tables[0].Rows[0]["ah"]!=null && ds.Tables[0].Rows[0]["ah"].ToString()!="")
				{
					this.ah=float.Parse(ds.Tables[0].Rows[0]["ah"].ToString());
				}
				if(ds.Tables[0].Rows[0]["m1"]!=null && ds.Tables[0].Rows[0]["m1"].ToString()!="")
				{
					this.m1=float.Parse(ds.Tables[0].Rows[0]["m1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["z1"]!=null && ds.Tables[0].Rows[0]["z1"].ToString()!="")
				{
					this.z1=float.Parse(ds.Tables[0].Rows[0]["z1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A1"]!=null && ds.Tables[0].Rows[0]["A1"].ToString()!="")
				{
					this.A1=float.Parse(ds.Tables[0].Rows[0]["A1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A2"]!=null && ds.Tables[0].Rows[0]["A2"].ToString()!="")
				{
					this.A2=float.Parse(ds.Tables[0].Rows[0]["A2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A3"]!=null && ds.Tables[0].Rows[0]["A3"].ToString()!="")
				{
					this.A3=float.Parse(ds.Tables[0].Rows[0]["A3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A4"]!=null && ds.Tables[0].Rows[0]["A4"].ToString()!="")
				{
					this.A4=float.Parse(ds.Tables[0].Rows[0]["A4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A5"]!=null && ds.Tables[0].Rows[0]["A5"].ToString()!="")
				{
					this.A5=float.Parse(ds.Tables[0].Rows[0]["A5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R1"]!=null && ds.Tables[0].Rows[0]["R1"].ToString()!="")
				{
					this.R1=float.Parse(ds.Tables[0].Rows[0]["R1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R2"]!=null && ds.Tables[0].Rows[0]["R2"].ToString()!="")
				{
					this.R2=float.Parse(ds.Tables[0].Rows[0]["R2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R3"]!=null && ds.Tables[0].Rows[0]["R3"].ToString()!="")
				{
					this.R3=float.Parse(ds.Tables[0].Rows[0]["R3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R4"]!=null && ds.Tables[0].Rows[0]["R4"].ToString()!="")
				{
					this.R4=float.Parse(ds.Tables[0].Rows[0]["R4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D"]!=null && ds.Tables[0].Rows[0]["D"].ToString()!="")
				{
					this.D=float.Parse(ds.Tables[0].Rows[0]["D"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D1"]!=null && ds.Tables[0].Rows[0]["D1"].ToString()!="")
				{
					this.D1=float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D2"]!=null && ds.Tables[0].Rows[0]["D2"].ToString()!="")
				{
					this.D2=float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D3"]!=null && ds.Tables[0].Rows[0]["D3"].ToString()!="")
				{
					this.D3=float.Parse(ds.Tables[0].Rows[0]["D3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D4"]!=null && ds.Tables[0].Rows[0]["D4"].ToString()!="")
				{
					this.D4=float.Parse(ds.Tables[0].Rows[0]["D4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D5"]!=null && ds.Tables[0].Rows[0]["D5"].ToString()!="")
				{
					this.D5=float.Parse(ds.Tables[0].Rows[0]["D5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D6"]!=null && ds.Tables[0].Rows[0]["D6"].ToString()!="")
				{
					this.D6=float.Parse(ds.Tables[0].Rows[0]["D6"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D7"]!=null && ds.Tables[0].Rows[0]["D7"].ToString()!="")
				{
					this.D7=float.Parse(ds.Tables[0].Rows[0]["D7"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D8"]!=null && ds.Tables[0].Rows[0]["D8"].ToString()!="")
				{
					this.D8=float.Parse(ds.Tables[0].Rows[0]["D8"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D9"]!=null && ds.Tables[0].Rows[0]["D9"].ToString()!="")
				{
					this.D9=float.Parse(ds.Tables[0].Rows[0]["D9"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D10"]!=null && ds.Tables[0].Rows[0]["D10"].ToString()!="")
				{
					this.D10=float.Parse(ds.Tables[0].Rows[0]["D10"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D11"]!=null && ds.Tables[0].Rows[0]["D11"].ToString()!="")
				{
					this.D11=float.Parse(ds.Tables[0].Rows[0]["D11"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DHH"]!=null && ds.Tables[0].Rows[0]["DHH"].ToString()!="")
				{
					this.DHH=float.Parse(ds.Tables[0].Rows[0]["DHH"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DH"]!=null && ds.Tables[0].Rows[0]["DH"].ToString()!="")
				{
					this.DH=float.Parse(ds.Tables[0].Rows[0]["DH"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DX"]!=null && ds.Tables[0].Rows[0]["DX"].ToString()!="")
				{
					this.DX=float.Parse(ds.Tables[0].Rows[0]["DX"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L1"]!=null && ds.Tables[0].Rows[0]["L1"].ToString()!="")
				{
					this.L1=float.Parse(ds.Tables[0].Rows[0]["L1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L2"]!=null && ds.Tables[0].Rows[0]["L2"].ToString()!="")
				{
					this.L2=float.Parse(ds.Tables[0].Rows[0]["L2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L3"]!=null && ds.Tables[0].Rows[0]["L3"].ToString()!="")
				{
					this.L3=float.Parse(ds.Tables[0].Rows[0]["L3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L4"]!=null && ds.Tables[0].Rows[0]["L4"].ToString()!="")
				{
					this.L4=float.Parse(ds.Tables[0].Rows[0]["L4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L5"]!=null && ds.Tables[0].Rows[0]["L5"].ToString()!="")
				{
					this.L5=float.Parse(ds.Tables[0].Rows[0]["L5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L6"]!=null && ds.Tables[0].Rows[0]["L6"].ToString()!="")
				{
					this.L6=float.Parse(ds.Tables[0].Rows[0]["L6"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L7"]!=null && ds.Tables[0].Rows[0]["L7"].ToString()!="")
				{
					this.L7=float.Parse(ds.Tables[0].Rows[0]["L7"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L8"]!=null && ds.Tables[0].Rows[0]["L8"].ToString()!="")
				{
					this.L8=float.Parse(ds.Tables[0].Rows[0]["L8"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L9"]!=null && ds.Tables[0].Rows[0]["L9"].ToString()!="")
				{
					this.L9=float.Parse(ds.Tables[0].Rows[0]["L9"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L10"]!=null && ds.Tables[0].Rows[0]["L10"].ToString()!="")
				{
					this.L10=float.Parse(ds.Tables[0].Rows[0]["L10"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L11"]!=null && ds.Tables[0].Rows[0]["L11"].ToString()!="")
				{
					this.L11=float.Parse(ds.Tables[0].Rows[0]["L11"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L12"]!=null && ds.Tables[0].Rows[0]["L12"].ToString()!="")
				{
					this.L12=float.Parse(ds.Tables[0].Rows[0]["L12"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L13"]!=null && ds.Tables[0].Rows[0]["L13"].ToString()!="")
				{
					this.L13=float.Parse(ds.Tables[0].Rows[0]["L13"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L14"]!=null && ds.Tables[0].Rows[0]["L14"].ToString()!="")
				{
					this.L14=float.Parse(ds.Tables[0].Rows[0]["L14"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L15"]!=null && ds.Tables[0].Rows[0]["L15"].ToString()!="")
				{
					this.L15=float.Parse(ds.Tables[0].Rows[0]["L15"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L16"]!=null && ds.Tables[0].Rows[0]["L16"].ToString()!="")
				{
					this.L16=float.Parse(ds.Tables[0].Rows[0]["L16"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L17"]!=null && ds.Tables[0].Rows[0]["L17"].ToString()!="")
				{
					this.L17=float.Parse(ds.Tables[0].Rows[0]["L17"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L18"]!=null && ds.Tables[0].Rows[0]["L18"].ToString()!="")
				{
					this.L18=float.Parse(ds.Tables[0].Rows[0]["L18"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L19"]!=null && ds.Tables[0].Rows[0]["L19"].ToString()!="")
				{
					this.L19=float.Parse(ds.Tables[0].Rows[0]["L19"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L20"]!=null && ds.Tables[0].Rows[0]["L20"].ToString()!="")
				{
					this.L20=float.Parse(ds.Tables[0].Rows[0]["L20"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L21"]!=null && ds.Tables[0].Rows[0]["L21"].ToString()!="")
				{
					this.L21=float.Parse(ds.Tables[0].Rows[0]["L21"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L22"]!=null && ds.Tables[0].Rows[0]["L22"].ToString()!="")
				{
					this.L22=float.Parse(ds.Tables[0].Rows[0]["L22"].ToString());
				}
				if(ds.Tables[0].Rows[0]["belta"]!=null && ds.Tables[0].Rows[0]["belta"].ToString()!="")
				{
					this.belta=float.Parse(ds.Tables[0].Rows[0]["belta"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DB"]!=null && ds.Tables[0].Rows[0]["DB"].ToString()!="")
				{
					this.DB=float.Parse(ds.Tables[0].Rows[0]["DB"].ToString());
				}
			}
		}

		/// <summary>
		/// 得到最大ID
		/// </summary>
		public int GetMaxId()
		{

		return DbHelperSQL.GetMaxID("ID", "主动齿轮_分动器"); 
		}

		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(int ID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from [主动齿轮_分动器]");
			strSql.Append(" where ID=@ID ");

			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = ID;

			return DbHelperSQL.Exists(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add()
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into [主动齿轮_分动器] (");
			strSql.Append("name,path,a,m,z,ah,m1,z1,A1,A2,A3,A4,A5,R1,R2,R3,R4,D,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,DHH,DH,DX,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L16,L17,L18,L19,L20,L21,L22,belta,DB)");
			strSql.Append(" values (");
			strSql.Append("@name,@path,@a,@m,@z,@ah,@m1,@z1,@A1,@A2,@A3,@A4,@A5,@R1,@R2,@R3,@R4,@D,@D1,@D2,@D3,@D4,@D5,@D6,@D7,@D8,@D9,@D10,@D11,@DHH,@DH,@DX,@L1,@L2,@L3,@L4,@L5,@L6,@L7,@L8,@L9,@L10,@L11,@L12,@L13,@L14,@L15,@L16,@L17,@L18,@L19,@L20,@L21,@L22,@belta,@DB)");
			strSql.Append(";select @@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@a", SqlDbType.Float,8),
					new SqlParameter("@m", SqlDbType.Float,8),
					new SqlParameter("@z", SqlDbType.Float,8),
					new SqlParameter("@ah", SqlDbType.Float,8),
					new SqlParameter("@m1", SqlDbType.Float,8),
					new SqlParameter("@z1", SqlDbType.Float,8),
					new SqlParameter("@A1", SqlDbType.Float,8),
					new SqlParameter("@A2", SqlDbType.Float,8),
					new SqlParameter("@A3", SqlDbType.Float,8),
					new SqlParameter("@A4", SqlDbType.Float,8),
					new SqlParameter("@A5", SqlDbType.Float,8),
					new SqlParameter("@R1", SqlDbType.Float,8),
					new SqlParameter("@R2", SqlDbType.Float,8),
					new SqlParameter("@R3", SqlDbType.Float,8),
					new SqlParameter("@R4", SqlDbType.Float,8),
					new SqlParameter("@D", SqlDbType.Float,8),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@D3", SqlDbType.Float,8),
					new SqlParameter("@D4", SqlDbType.Float,8),
					new SqlParameter("@D5", SqlDbType.Float,8),
					new SqlParameter("@D6", SqlDbType.Float,8),
					new SqlParameter("@D7", SqlDbType.Float,8),
					new SqlParameter("@D8", SqlDbType.Float,8),
					new SqlParameter("@D9", SqlDbType.Float,8),
					new SqlParameter("@D10", SqlDbType.Float,8),
					new SqlParameter("@D11", SqlDbType.Float,8),
					new SqlParameter("@DHH", SqlDbType.Float,8),
					new SqlParameter("@DH", SqlDbType.Float,8),
					new SqlParameter("@DX", SqlDbType.Float,8),
					new SqlParameter("@L1", SqlDbType.Float,8),
					new SqlParameter("@L2", SqlDbType.Float,8),
					new SqlParameter("@L3", SqlDbType.Float,8),
					new SqlParameter("@L4", SqlDbType.Float,8),
					new SqlParameter("@L5", SqlDbType.Float,8),
					new SqlParameter("@L6", SqlDbType.Float,8),
					new SqlParameter("@L7", SqlDbType.Float,8),
					new SqlParameter("@L8", SqlDbType.Float,8),
					new SqlParameter("@L9", SqlDbType.Float,8),
					new SqlParameter("@L10", SqlDbType.Float,8),
					new SqlParameter("@L11", SqlDbType.Float,8),
					new SqlParameter("@L12", SqlDbType.Float,8),
					new SqlParameter("@L13", SqlDbType.Float,8),
					new SqlParameter("@L14", SqlDbType.Float,8),
					new SqlParameter("@L15", SqlDbType.Float,8),
					new SqlParameter("@L16", SqlDbType.Float,8),
					new SqlParameter("@L17", SqlDbType.Float,8),
					new SqlParameter("@L18", SqlDbType.Float,8),
					new SqlParameter("@L19", SqlDbType.Float,8),
					new SqlParameter("@L20", SqlDbType.Float,8),
					new SqlParameter("@L21", SqlDbType.Float,8),
					new SqlParameter("@L22", SqlDbType.Float,8),
					new SqlParameter("@belta", SqlDbType.Float,8),
					new SqlParameter("@DB", SqlDbType.Float,8)};
			parameters[0].Value = name;
			parameters[1].Value = path;
			parameters[2].Value = a;
			parameters[3].Value = m;
			parameters[4].Value = z;
			parameters[5].Value = ah;
			parameters[6].Value = m1;
			parameters[7].Value = z1;
			parameters[8].Value = A1;
			parameters[9].Value = A2;
			parameters[10].Value = A3;
			parameters[11].Value = A4;
			parameters[12].Value = A5;
			parameters[13].Value = R1;
			parameters[14].Value = R2;
			parameters[15].Value = R3;
			parameters[16].Value = R4;
			parameters[17].Value = D;
			parameters[18].Value = D1;
			parameters[19].Value = D2;
			parameters[20].Value = D3;
			parameters[21].Value = D4;
			parameters[22].Value = D5;
			parameters[23].Value = D6;
			parameters[24].Value = D7;
			parameters[25].Value = D8;
			parameters[26].Value = D9;
			parameters[27].Value = D10;
			parameters[28].Value = D11;
			parameters[29].Value = DHH;
			parameters[30].Value = DH;
			parameters[31].Value = DX;
			parameters[32].Value = L1;
			parameters[33].Value = L2;
			parameters[34].Value = L3;
			parameters[35].Value = L4;
			parameters[36].Value = L5;
			parameters[37].Value = L6;
			parameters[38].Value = L7;
			parameters[39].Value = L8;
			parameters[40].Value = L9;
			parameters[41].Value = L10;
			parameters[42].Value = L11;
			parameters[43].Value = L12;
			parameters[44].Value = L13;
			parameters[45].Value = L14;
			parameters[46].Value = L15;
			parameters[47].Value = L16;
			parameters[48].Value = L17;
			parameters[49].Value = L18;
			parameters[50].Value = L19;
			parameters[51].Value = L20;
			parameters[52].Value = L21;
			parameters[53].Value = L22;
			parameters[54].Value = belta;
			parameters[55].Value = DB;

			object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update()
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update [主动齿轮_分动器] set ");
			strSql.Append("name=@name,");
			strSql.Append("path=@path,");
			strSql.Append("a=@a,");
			strSql.Append("m=@m,");
			strSql.Append("z=@z,");
			strSql.Append("ah=@ah,");
			strSql.Append("m1=@m1,");
			strSql.Append("z1=@z1,");
			strSql.Append("A1=@A1,");
			strSql.Append("A2=@A2,");
			strSql.Append("A3=@A3,");
			strSql.Append("A4=@A4,");
			strSql.Append("A5=@A5,");
			strSql.Append("R1=@R1,");
			strSql.Append("R2=@R2,");
			strSql.Append("R3=@R3,");
			strSql.Append("R4=@R4,");
			strSql.Append("D=@D,");
			strSql.Append("D1=@D1,");
			strSql.Append("D2=@D2,");
			strSql.Append("D3=@D3,");
			strSql.Append("D4=@D4,");
			strSql.Append("D5=@D5,");
			strSql.Append("D6=@D6,");
			strSql.Append("D7=@D7,");
			strSql.Append("D8=@D8,");
			strSql.Append("D9=@D9,");
			strSql.Append("D10=@D10,");
			strSql.Append("D11=@D11,");
			strSql.Append("DHH=@DHH,");
			strSql.Append("DH=@DH,");
			strSql.Append("DX=@DX,");
			strSql.Append("L1=@L1,");
			strSql.Append("L2=@L2,");
			strSql.Append("L3=@L3,");
			strSql.Append("L4=@L4,");
			strSql.Append("L5=@L5,");
			strSql.Append("L6=@L6,");
			strSql.Append("L7=@L7,");
			strSql.Append("L8=@L8,");
			strSql.Append("L9=@L9,");
			strSql.Append("L10=@L10,");
			strSql.Append("L11=@L11,");
			strSql.Append("L12=@L12,");
			strSql.Append("L13=@L13,");
			strSql.Append("L14=@L14,");
			strSql.Append("L15=@L15,");
			strSql.Append("L16=@L16,");
			strSql.Append("L17=@L17,");
			strSql.Append("L18=@L18,");
			strSql.Append("L19=@L19,");
			strSql.Append("L20=@L20,");
			strSql.Append("L21=@L21,");
			strSql.Append("L22=@L22,");
			strSql.Append("belta=@belta,");
			strSql.Append("DB=@DB");
			strSql.Append(" where ID=@ID ");
			SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@a", SqlDbType.Float,8),
					new SqlParameter("@m", SqlDbType.Float,8),
					new SqlParameter("@z", SqlDbType.Float,8),
					new SqlParameter("@ah", SqlDbType.Float,8),
					new SqlParameter("@m1", SqlDbType.Float,8),
					new SqlParameter("@z1", SqlDbType.Float,8),
					new SqlParameter("@A1", SqlDbType.Float,8),
					new SqlParameter("@A2", SqlDbType.Float,8),
					new SqlParameter("@A3", SqlDbType.Float,8),
					new SqlParameter("@A4", SqlDbType.Float,8),
					new SqlParameter("@A5", SqlDbType.Float,8),
					new SqlParameter("@R1", SqlDbType.Float,8),
					new SqlParameter("@R2", SqlDbType.Float,8),
					new SqlParameter("@R3", SqlDbType.Float,8),
					new SqlParameter("@R4", SqlDbType.Float,8),
					new SqlParameter("@D", SqlDbType.Float,8),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@D3", SqlDbType.Float,8),
					new SqlParameter("@D4", SqlDbType.Float,8),
					new SqlParameter("@D5", SqlDbType.Float,8),
					new SqlParameter("@D6", SqlDbType.Float,8),
					new SqlParameter("@D7", SqlDbType.Float,8),
					new SqlParameter("@D8", SqlDbType.Float,8),
					new SqlParameter("@D9", SqlDbType.Float,8),
					new SqlParameter("@D10", SqlDbType.Float,8),
					new SqlParameter("@D11", SqlDbType.Float,8),
					new SqlParameter("@DHH", SqlDbType.Float,8),
					new SqlParameter("@DH", SqlDbType.Float,8),
					new SqlParameter("@DX", SqlDbType.Float,8),
					new SqlParameter("@L1", SqlDbType.Float,8),
					new SqlParameter("@L2", SqlDbType.Float,8),
					new SqlParameter("@L3", SqlDbType.Float,8),
					new SqlParameter("@L4", SqlDbType.Float,8),
					new SqlParameter("@L5", SqlDbType.Float,8),
					new SqlParameter("@L6", SqlDbType.Float,8),
					new SqlParameter("@L7", SqlDbType.Float,8),
					new SqlParameter("@L8", SqlDbType.Float,8),
					new SqlParameter("@L9", SqlDbType.Float,8),
					new SqlParameter("@L10", SqlDbType.Float,8),
					new SqlParameter("@L11", SqlDbType.Float,8),
					new SqlParameter("@L12", SqlDbType.Float,8),
					new SqlParameter("@L13", SqlDbType.Float,8),
					new SqlParameter("@L14", SqlDbType.Float,8),
					new SqlParameter("@L15", SqlDbType.Float,8),
					new SqlParameter("@L16", SqlDbType.Float,8),
					new SqlParameter("@L17", SqlDbType.Float,8),
					new SqlParameter("@L18", SqlDbType.Float,8),
					new SqlParameter("@L19", SqlDbType.Float,8),
					new SqlParameter("@L20", SqlDbType.Float,8),
					new SqlParameter("@L21", SqlDbType.Float,8),
					new SqlParameter("@L22", SqlDbType.Float,8),
					new SqlParameter("@belta", SqlDbType.Float,8),
					new SqlParameter("@DB", SqlDbType.Float,8),
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = name;
			parameters[1].Value = path;
			parameters[2].Value = a;
			parameters[3].Value = m;
			parameters[4].Value = z;
			parameters[5].Value = ah;
			parameters[6].Value = m1;
			parameters[7].Value = z1;
			parameters[8].Value = A1;
			parameters[9].Value = A2;
			parameters[10].Value = A3;
			parameters[11].Value = A4;
			parameters[12].Value = A5;
			parameters[13].Value = R1;
			parameters[14].Value = R2;
			parameters[15].Value = R3;
			parameters[16].Value = R4;
			parameters[17].Value = D;
			parameters[18].Value = D1;
			parameters[19].Value = D2;
			parameters[20].Value = D3;
			parameters[21].Value = D4;
			parameters[22].Value = D5;
			parameters[23].Value = D6;
			parameters[24].Value = D7;
			parameters[25].Value = D8;
			parameters[26].Value = D9;
			parameters[27].Value = D10;
			parameters[28].Value = D11;
			parameters[29].Value = DHH;
			parameters[30].Value = DH;
			parameters[31].Value = DX;
			parameters[32].Value = L1;
			parameters[33].Value = L2;
			parameters[34].Value = L3;
			parameters[35].Value = L4;
			parameters[36].Value = L5;
			parameters[37].Value = L6;
			parameters[38].Value = L7;
			parameters[39].Value = L8;
			parameters[40].Value = L9;
			parameters[41].Value = L10;
			parameters[42].Value = L11;
			parameters[43].Value = L12;
			parameters[44].Value = L13;
			parameters[45].Value = L14;
			parameters[46].Value = L15;
			parameters[47].Value = L16;
			parameters[48].Value = L17;
			parameters[49].Value = L18;
			parameters[50].Value = L19;
			parameters[51].Value = L20;
			parameters[52].Value = L21;
			parameters[53].Value = L22;
			parameters[54].Value = belta;
			parameters[55].Value = DB;
			parameters[56].Value = ID;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool Delete(int ID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from [主动齿轮_分动器] ");
			strSql.Append(" where ID=@ID ");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = ID;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public void GetModel(int ID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select ID,name,path,a,m,z,ah,m1,z1,A1,A2,A3,A4,A5,R1,R2,R3,R4,D,D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,DHH,DH,DX,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L16,L17,L18,L19,L20,L21,L22,belta,DB ");
			strSql.Append(" FROM [主动齿轮_分动器] ");
			strSql.Append(" where ID=@ID ");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = ID;

			DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				if(ds.Tables[0].Rows[0]["ID"]!=null && ds.Tables[0].Rows[0]["ID"].ToString()!="")
				{
					this.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
				}
				if(ds.Tables[0].Rows[0]["name"]!=null && ds.Tables[0].Rows[0]["name"].ToString()!="")
				{
					this.name=ds.Tables[0].Rows[0]["name"].ToString();
				}
				if(ds.Tables[0].Rows[0]["path"]!=null && ds.Tables[0].Rows[0]["path"].ToString()!="")
				{
					this.path=ds.Tables[0].Rows[0]["path"].ToString();
				}
				if(ds.Tables[0].Rows[0]["a"]!=null && ds.Tables[0].Rows[0]["a"].ToString()!="")
				{
					this.a=float.Parse(ds.Tables[0].Rows[0]["a"].ToString());
				}
				if(ds.Tables[0].Rows[0]["m"]!=null && ds.Tables[0].Rows[0]["m"].ToString()!="")
				{
					this.m=float.Parse(ds.Tables[0].Rows[0]["m"].ToString());
				}
				if(ds.Tables[0].Rows[0]["z"]!=null && ds.Tables[0].Rows[0]["z"].ToString()!="")
				{
					this.z=float.Parse(ds.Tables[0].Rows[0]["z"].ToString());
				}
				if(ds.Tables[0].Rows[0]["ah"]!=null && ds.Tables[0].Rows[0]["ah"].ToString()!="")
				{
					this.ah=float.Parse(ds.Tables[0].Rows[0]["ah"].ToString());
				}
				if(ds.Tables[0].Rows[0]["m1"]!=null && ds.Tables[0].Rows[0]["m1"].ToString()!="")
				{
					this.m1=float.Parse(ds.Tables[0].Rows[0]["m1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["z1"]!=null && ds.Tables[0].Rows[0]["z1"].ToString()!="")
				{
					this.z1=float.Parse(ds.Tables[0].Rows[0]["z1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A1"]!=null && ds.Tables[0].Rows[0]["A1"].ToString()!="")
				{
					this.A1=float.Parse(ds.Tables[0].Rows[0]["A1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A2"]!=null && ds.Tables[0].Rows[0]["A2"].ToString()!="")
				{
					this.A2=float.Parse(ds.Tables[0].Rows[0]["A2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A3"]!=null && ds.Tables[0].Rows[0]["A3"].ToString()!="")
				{
					this.A3=float.Parse(ds.Tables[0].Rows[0]["A3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A4"]!=null && ds.Tables[0].Rows[0]["A4"].ToString()!="")
				{
					this.A4=float.Parse(ds.Tables[0].Rows[0]["A4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["A5"]!=null && ds.Tables[0].Rows[0]["A5"].ToString()!="")
				{
					this.A5=float.Parse(ds.Tables[0].Rows[0]["A5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R1"]!=null && ds.Tables[0].Rows[0]["R1"].ToString()!="")
				{
					this.R1=float.Parse(ds.Tables[0].Rows[0]["R1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R2"]!=null && ds.Tables[0].Rows[0]["R2"].ToString()!="")
				{
					this.R2=float.Parse(ds.Tables[0].Rows[0]["R2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R3"]!=null && ds.Tables[0].Rows[0]["R3"].ToString()!="")
				{
					this.R3=float.Parse(ds.Tables[0].Rows[0]["R3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["R4"]!=null && ds.Tables[0].Rows[0]["R4"].ToString()!="")
				{
					this.R4=float.Parse(ds.Tables[0].Rows[0]["R4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D"]!=null && ds.Tables[0].Rows[0]["D"].ToString()!="")
				{
					this.D=float.Parse(ds.Tables[0].Rows[0]["D"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D1"]!=null && ds.Tables[0].Rows[0]["D1"].ToString()!="")
				{
					this.D1=float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D2"]!=null && ds.Tables[0].Rows[0]["D2"].ToString()!="")
				{
					this.D2=float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D3"]!=null && ds.Tables[0].Rows[0]["D3"].ToString()!="")
				{
					this.D3=float.Parse(ds.Tables[0].Rows[0]["D3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D4"]!=null && ds.Tables[0].Rows[0]["D4"].ToString()!="")
				{
					this.D4=float.Parse(ds.Tables[0].Rows[0]["D4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D5"]!=null && ds.Tables[0].Rows[0]["D5"].ToString()!="")
				{
					this.D5=float.Parse(ds.Tables[0].Rows[0]["D5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D6"]!=null && ds.Tables[0].Rows[0]["D6"].ToString()!="")
				{
					this.D6=float.Parse(ds.Tables[0].Rows[0]["D6"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D7"]!=null && ds.Tables[0].Rows[0]["D7"].ToString()!="")
				{
					this.D7=float.Parse(ds.Tables[0].Rows[0]["D7"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D8"]!=null && ds.Tables[0].Rows[0]["D8"].ToString()!="")
				{
					this.D8=float.Parse(ds.Tables[0].Rows[0]["D8"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D9"]!=null && ds.Tables[0].Rows[0]["D9"].ToString()!="")
				{
					this.D9=float.Parse(ds.Tables[0].Rows[0]["D9"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D10"]!=null && ds.Tables[0].Rows[0]["D10"].ToString()!="")
				{
					this.D10=float.Parse(ds.Tables[0].Rows[0]["D10"].ToString());
				}
				if(ds.Tables[0].Rows[0]["D11"]!=null && ds.Tables[0].Rows[0]["D11"].ToString()!="")
				{
					this.D11=float.Parse(ds.Tables[0].Rows[0]["D11"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DHH"]!=null && ds.Tables[0].Rows[0]["DHH"].ToString()!="")
				{
					this.DHH=float.Parse(ds.Tables[0].Rows[0]["DHH"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DH"]!=null && ds.Tables[0].Rows[0]["DH"].ToString()!="")
				{
					this.DH=float.Parse(ds.Tables[0].Rows[0]["DH"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DX"]!=null && ds.Tables[0].Rows[0]["DX"].ToString()!="")
				{
					this.DX=float.Parse(ds.Tables[0].Rows[0]["DX"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L1"]!=null && ds.Tables[0].Rows[0]["L1"].ToString()!="")
				{
					this.L1=float.Parse(ds.Tables[0].Rows[0]["L1"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L2"]!=null && ds.Tables[0].Rows[0]["L2"].ToString()!="")
				{
					this.L2=float.Parse(ds.Tables[0].Rows[0]["L2"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L3"]!=null && ds.Tables[0].Rows[0]["L3"].ToString()!="")
				{
					this.L3=float.Parse(ds.Tables[0].Rows[0]["L3"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L4"]!=null && ds.Tables[0].Rows[0]["L4"].ToString()!="")
				{
					this.L4=float.Parse(ds.Tables[0].Rows[0]["L4"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L5"]!=null && ds.Tables[0].Rows[0]["L5"].ToString()!="")
				{
					this.L5=float.Parse(ds.Tables[0].Rows[0]["L5"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L6"]!=null && ds.Tables[0].Rows[0]["L6"].ToString()!="")
				{
					this.L6=float.Parse(ds.Tables[0].Rows[0]["L6"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L7"]!=null && ds.Tables[0].Rows[0]["L7"].ToString()!="")
				{
					this.L7=float.Parse(ds.Tables[0].Rows[0]["L7"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L8"]!=null && ds.Tables[0].Rows[0]["L8"].ToString()!="")
				{
					this.L8=float.Parse(ds.Tables[0].Rows[0]["L8"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L9"]!=null && ds.Tables[0].Rows[0]["L9"].ToString()!="")
				{
					this.L9=float.Parse(ds.Tables[0].Rows[0]["L9"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L10"]!=null && ds.Tables[0].Rows[0]["L10"].ToString()!="")
				{
					this.L10=float.Parse(ds.Tables[0].Rows[0]["L10"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L11"]!=null && ds.Tables[0].Rows[0]["L11"].ToString()!="")
				{
					this.L11=float.Parse(ds.Tables[0].Rows[0]["L11"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L12"]!=null && ds.Tables[0].Rows[0]["L12"].ToString()!="")
				{
					this.L12=float.Parse(ds.Tables[0].Rows[0]["L12"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L13"]!=null && ds.Tables[0].Rows[0]["L13"].ToString()!="")
				{
					this.L13=float.Parse(ds.Tables[0].Rows[0]["L13"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L14"]!=null && ds.Tables[0].Rows[0]["L14"].ToString()!="")
				{
					this.L14=float.Parse(ds.Tables[0].Rows[0]["L14"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L15"]!=null && ds.Tables[0].Rows[0]["L15"].ToString()!="")
				{
					this.L15=float.Parse(ds.Tables[0].Rows[0]["L15"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L16"]!=null && ds.Tables[0].Rows[0]["L16"].ToString()!="")
				{
					this.L16=float.Parse(ds.Tables[0].Rows[0]["L16"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L17"]!=null && ds.Tables[0].Rows[0]["L17"].ToString()!="")
				{
					this.L17=float.Parse(ds.Tables[0].Rows[0]["L17"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L18"]!=null && ds.Tables[0].Rows[0]["L18"].ToString()!="")
				{
					this.L18=float.Parse(ds.Tables[0].Rows[0]["L18"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L19"]!=null && ds.Tables[0].Rows[0]["L19"].ToString()!="")
				{
					this.L19=float.Parse(ds.Tables[0].Rows[0]["L19"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L20"]!=null && ds.Tables[0].Rows[0]["L20"].ToString()!="")
				{
					this.L20=float.Parse(ds.Tables[0].Rows[0]["L20"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L21"]!=null && ds.Tables[0].Rows[0]["L21"].ToString()!="")
				{
					this.L21=float.Parse(ds.Tables[0].Rows[0]["L21"].ToString());
				}
				if(ds.Tables[0].Rows[0]["L22"]!=null && ds.Tables[0].Rows[0]["L22"].ToString()!="")
				{
					this.L22=float.Parse(ds.Tables[0].Rows[0]["L22"].ToString());
				}
				if(ds.Tables[0].Rows[0]["belta"]!=null && ds.Tables[0].Rows[0]["belta"].ToString()!="")
				{
					this.belta=float.Parse(ds.Tables[0].Rows[0]["belta"].ToString());
				}
				if(ds.Tables[0].Rows[0]["DB"]!=null && ds.Tables[0].Rows[0]["DB"].ToString()!="")
				{
					this.DB=float.Parse(ds.Tables[0].Rows[0]["DB"].ToString());
				}
			}
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select * ");
			strSql.Append(" FROM [主动齿轮_分动器] ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			return DbHelperSQL.Query(strSql.ToString());
		}

		#endregion  Method
	}
}

